{# **
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://devdocs.prestashop.com/ for more information.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @copyright Since 2007 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * #}
{% extends '@PrestaShop/Admin/layout.html.twig' %}
{% trans_default_domain 'Admin.Advparameters.Feature' %}

{% block content %}
  {% block sql_manager_info_block %}
    <div class="alert alert-info" role="alert">
      <p class="alert-text">{{ 'How do I create a new SQL query?'|trans({}, 'Admin.Advparameters.Help') }}</p>
      <ul>
        <li>{{ 'Click "%add_new_label%".'|trans({'%add_new_label%': 'Add new SQL query'|trans({}, 'Admin.Advparameters.Feature')}, 'Admin.Advparameters.Help') }}</li>
        <li>{{ 'Fill in the fields and click "%save_label%".'|trans({'%save_label%': 'Save'|trans({}, 'Admin.Actions')}, 'Admin.Advparameters.Help') }}</li>
        <li>{{ 'You can then view the query results by clicking on the "%view_label%" action in the dropdown menu'|trans({'%view_label%': 'View'|trans({}, 'Admin.Global')}, 'Admin.Advparameters.Help') }}</li>
        <li>{{ 'You can also export the query results as a CSV file by clicking on the "%export_label%" button'|trans({'%export_label%': 'Export'|trans({}, 'Admin.Actions')}, 'Admin.Advparameters.Help') }}</li>
      </ul>
    </div>
  {% endblock %}

  {% block sql_manager_warning_block %}
    <div class="alert alert-warning" role="alert">
      <p class="alert-text">{{ 'When saving the query, only the "SELECT" SQL statement is allowed.'|trans({}, 'Admin.Advparameters.Notification') }}</p>
    </div>
  {% endblock %}

  {% block sql_manager_list_panel %}

    {{ include('@PrestaShop/Admin/Common/Grid/grid_panel.html.twig', {grid: requestSqlGrid}) }}

  {% endblock %}

  {% block sql_manager_settings_panel %}

    {{ include('@PrestaShop/Admin/Configure/AdvancedParameters/RequestSql/Blocks/settings_panel.html.twig') }}

  {% endblock %}
{% endblock %}

{% block javascripts %}
  {{ parent() }}

  <script src="{{ asset('themes/new-theme/public/sql_manager.bundle.js') }}"></script>
  <script src="{{ asset('themes/default/js/bundle/pagination.js') }}"></script>
{% endblock %}
